Change cell references in formulas to names

1. Do one of the following:
   • Select the range of cells that contains formulas in which you want to replace references with names.

   • Select a single cell to change the references to names in all formulas on the worksheet.

2. On the Insert menu, point to Name, and then click Apply.
3. In the Apply names box, click one or more names.